Release 10.1A: OpenEdge Data Management:
DataServer for ORACLE

Cursors

The Progress 4GL uses cursors to keep track of where it is in a file. A cursor is like a pointer that points to consecutive records in a file. For example, the Progress 4GL uses cursors when it processes FOR EACH types of statements. The Progress 4GL maintains cursor positioning across queries.

The DataServer supports this behavior for ORACLE tables that have a mandatory unique index on an integer column or that contain the PROGRESS_RECID column. (The Progress-to-ORACLE migration utility creates an indexed NUMBER column named PROGRESS_RECID with unique values for the rows in each ORACLE table.)

Suppose that you are reading records from the customer file using the cust-num index, and your “current” record is customer number 50. This means that the Progress 4GL has a cursor positioned at cust-num 50.